UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'stgf4yk7wo49EFmyUAEdu2K/zXpl/2bnyIuJTLxKuG8='
WHERE
key_id = '822d94c701abf976db4ca51bbdf2386a879b513254c16f974a4a599e88fb25f3'
AND (
token = 'stgf4yk7wo49EFmyUAEdu2K/zXpl/2bnyIuJTLxKuG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)