UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8N2jRQym6+qQQB57nl8Hkl0B1hzukMpEhFV39oO43L8=' 
WHERE 
  key_id = 'eafae1980f841ea6433b0ba19361983c54d73e07cca261bfc339e53620dde9c2' 
  AND (
    token = '8N2jRQym6+qQQB57nl8Hkl0B1hzukMpEhFV39oO43L8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052