UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CxIdTWQ9IknIXE3GDlel7/l0nbGv9F3OS0erllRzctA='
WHERE
key_id = 'c46789c533fb84df52f66420c68b4a2cf9fb3ef7fea205b2e38187375a4aa78b'
AND (
token = 'CxIdTWQ9IknIXE3GDlel7/l0nbGv9F3OS0erllRzctA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)