UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MEqs5lxSQQ4DcmYSnkA2PkJck3s283SCHX682kheIxA=' 
WHERE 
  key_id = '58764cd7c9bebee1e240bec5e4c5c00e7bc44bb488c55bf18b25de160363ac29' 
  AND (
    token = 'MEqs5lxSQQ4DcmYSnkA2PkJck3s283SCHX682kheIxA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048