UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NWqxVZZjNdmIJ4PDe6hnwhH7AV3fOhjSb+2WeHRZDA='
WHERE
key_id = 'e5caff1a430cfcf6f976d80d77f0943ffdd8baf3a709c8cc24be9319e31ea765'
AND (
token = '8NWqxVZZjNdmIJ4PDe6hnwhH7AV3fOhjSb+2WeHRZDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)