UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0D1WsMEWzNm/LX1y0hAUHWBu5y5rGla9sWh/eoS8xy0='
WHERE
key_id = 'f52f2c89c8e7c938580d70689b3e84ff3b6824abfc7ef3417dbd37f17bdf6bec'
AND (
token = '0D1WsMEWzNm/LX1y0hAUHWBu5y5rGla9sWh/eoS8xy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)