UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXjfSinWQfTvk229sJsWH0EnQNpLdzJMUaQ1JhamK20='
WHERE
key_id = '3f0cbfbe9bb31a1dabe9dc47c166e12b6595a0baf3215e13b6e5f46ef99523a0'
AND (
token = 'WXjfSinWQfTvk229sJsWH0EnQNpLdzJMUaQ1JhamK20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)