UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bhYeth5Y1A9wNNGZgze+NdjhvTyT2jYItAjh4rue/OA=' 
WHERE 
  key_id = 'ef2007cf6fe7c5e23b4867e92bb1dec57b6e4e919d5df4428b5180e2d5db1587' 
  AND (
    token = 'bhYeth5Y1A9wNNGZgze+NdjhvTyT2jYItAjh4rue/OA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032