UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wsNkUCqx1gGk5Te+xl96JS58j3JuRHFYoWOSfPUo+xw=' 
WHERE 
  key_id = 'f7c9a06b8493bb7ec83b0563ffea4f511f7d4f6f6f97fb74a98a6190e8a8d5d0' 
  AND (
    token = 'wsNkUCqx1gGk5Te+xl96JS58j3JuRHFYoWOSfPUo+xw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024