UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/cEmCtWVC0PpJSl6ZEElI8pJ6Nu9pohXLUCWTYcWnC4='
WHERE
key_id = '1ec4a77b01ec0353b40b1cd037a2f671324a0f6f75fe9b7e5ff5cc1735dfa113'
AND (
token = '/cEmCtWVC0PpJSl6ZEElI8pJ6Nu9pohXLUCWTYcWnC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)