UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHi4BtFYezpJZJIEV+2BB7naXk5FVHH65+I6P8vDrig='
WHERE
key_id = '64f1ffb5b5b92e864a59f809931827ee41b728026716c3464e0d648ae8078641'
AND (
token = 'ZHi4BtFYezpJZJIEV+2BB7naXk5FVHH65+I6P8vDrig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)