UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VgKmkoie0I5SCiQr8QLCBF6mjfz8Ct5JChnTLakxwA='
WHERE
key_id = 'd85fc16df22942cc2e814e30f1a542f140e361b1948b5456ce09a5715bdd87f9'
AND (
token = '/VgKmkoie0I5SCiQr8QLCBF6mjfz8Ct5JChnTLakxwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)