UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/mSh1c6Ihr4r3RpiFq4MTU+QN2JslAwtjlQXk9PSG24=' 
WHERE 
  key_id = '642e36f4c5ce1f3f93e8990d9b63972ab42e55ac583686f4464646f9efe9ceae' 
  AND (
    token = '/mSh1c6Ihr4r3RpiFq4MTU+QN2JslAwtjlQXk9PSG24=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030