UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KcazyHZ5fG7kK6IQIWlG64CI5brrRdgrLe4gLX+QmZw='
WHERE
key_id = '1564b26e56e3209a5dea167db0bfe2265c697e6c112924a4e7f80a07de88a3a5'
AND (
token = 'KcazyHZ5fG7kK6IQIWlG64CI5brrRdgrLe4gLX+QmZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)