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