UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KDgI9bEdBOgUY4LfQag9YBUs3GvIRTmxg9hQ0CA23Q='
WHERE
key_id = '7ddb000f5db4316c92d777b705327da52f1cb2aadc87ae5d2f3fccfd62006f0f'
AND (
token = '7KDgI9bEdBOgUY4LfQag9YBUs3GvIRTmxg9hQ0CA23Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)