UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZpStvgwAxERiYZgXlx6eBL9IH5+cSLhf3P8C+KUQwg='
WHERE
key_id = '49930eeb31a2e0952652278b2511e7e306ea60e6c73d8a281567c65eebe87d5f'
AND (
token = 'gZpStvgwAxERiYZgXlx6eBL9IH5+cSLhf3P8C+KUQwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)