UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lqOiGW+kOnap48Q4/WA94VBLS6dW1oadtdgQtT6eDc='
WHERE
key_id = '4696c6ec8f2d3352c6614da154610593476b96310a77887a57e6e61426db6246'
AND (
token = '8lqOiGW+kOnap48Q4/WA94VBLS6dW1oadtdgQtT6eDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)