UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9C19tdJ6Jvwlgen7jKXVJYwiZTXzq1P0hD8hPiPADxs='
WHERE
key_id = 'f669439e8c835a3225747c68f8df8cd0113dbe4da491498647c5add05591e9d7'
AND (
token = '9C19tdJ6Jvwlgen7jKXVJYwiZTXzq1P0hD8hPiPADxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)