UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VW09RhP1kKo58Hek2abtz/1UahHKrtXlV11zbg9zGH4=' 
WHERE 
  key_id = '83eea9a4eee6c59cf106561bafc61a0b5ca58426b85f47b37186c8d94a51f97b' 
  AND (
    token = 'VW09RhP1kKo58Hek2abtz/1UahHKrtXlV11zbg9zGH4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030