UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WAsRAV2uGE5hJ2bhR9fMn49LaxcJFT/H8GJbveGmQIM=' 
WHERE 
  key_id = '3e0e8a4018d68aa2f10fc298a8f0d24dffce0be9cc21f4c157d9fab8b9847997' 
  AND (
    token = 'WAsRAV2uGE5hJ2bhR9fMn49LaxcJFT/H8GJbveGmQIM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021