UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hEHolZl8chkQK6/y7/iIQdnskxDwo0p2czMXzCSYD4='
WHERE
key_id = '8b0d47260e5f3b1f6211751632d86ac75e22311dd9d79e842fc3e9274a8efdc3'
AND (
token = '/hEHolZl8chkQK6/y7/iIQdnskxDwo0p2czMXzCSYD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)