UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQ0NJ3O7DCuRuXeUfI3riDYXQU1WOTek57+RIpgRgI8='
WHERE
key_id = 'd0727e0051d4ea239b93dd695a95f223c88048c16d607a6a8a0701d504b9627f'
AND (
token = 'hQ0NJ3O7DCuRuXeUfI3riDYXQU1WOTek57+RIpgRgI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)