UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S5BBO9unYWlhLsCe79P9pQQKu1LdC/3KWL+c7qT+RSc='
WHERE
key_id = '9927c5782036a29440e8d74d9a556d9079e6161d1e9027a85a6d53f3528f6d94'
AND (
token = 'S5BBO9unYWlhLsCe79P9pQQKu1LdC/3KWL+c7qT+RSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)