UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'D6ucdgCLXbYdGKDY8Srxcka2GIE4FPUQgr505SjdlCc=' 
WHERE 
  key_id = 'a480a02a57e348e623414f7e6bb22816921341f6823a3c9fa329a245f2d4accb' 
  AND (
    token = 'D6ucdgCLXbYdGKDY8Srxcka2GIE4FPUQgr505SjdlCc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021