UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MCdNk6E5s/ydzQIInH8D7iVtweG5sm3c6c5aiLyKWeU=' 
WHERE 
  key_id = '9424fbf32b165500ab8f53817ad6fb8b4098761ef0c3138008cb25b9c3e72833' 
  AND (
    token = 'MCdNk6E5s/ydzQIInH8D7iVtweG5sm3c6c5aiLyKWeU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024