UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KvICcqvI1TZ6BWdQ43erepg3adHVcE/r8Yjb/AYQ0YQ=' 
WHERE 
  key_id = '938793b5aae76a8995f89ca08d8d9eac692d4f31f7b605af8eec628a365e7415' 
  AND (
    token = 'KvICcqvI1TZ6BWdQ43erepg3adHVcE/r8Yjb/AYQ0YQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025