UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'drpsSpBZo3RiLNOu9PqXmuHRUsIPrMptqegFivSY9UI='
WHERE
key_id = '6e9ede99ed420dca35ae704a5ab486f2c5077f1b09879fd1293cc8e21ccabe07'
AND (
token = 'drpsSpBZo3RiLNOu9PqXmuHRUsIPrMptqegFivSY9UI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)