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