UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T0GS6Gy58Hj+Z43JV7GVSR5I3czDumQAP4wuUf/xiHw='
WHERE
key_id = 'c9db744946fff70e88a0246cbf377e76c7e088e4b13ffafe5529a25adf79ac73'
AND (
token = 'T0GS6Gy58Hj+Z43JV7GVSR5I3czDumQAP4wuUf/xiHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)