UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M7fxyVKuZ3VWQjVThbiJqCt2t1dDU6k2tsuUDbqtZHw='
WHERE
key_id = '335f57221df9e42e48758e0458747090242b777a4b782d9113f70fe9181abaec'
AND (
token = 'M7fxyVKuZ3VWQjVThbiJqCt2t1dDU6k2tsuUDbqtZHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)