UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vr9XvKS1pWTlM3XiB6rpZ9uT+A0Dtfy1eKPDzIubBvU='
WHERE
key_id = '15f843b9031c11e23a08f4e57b5ac9cf3ee71adf9a1232b5e71eed43cf596069'
AND (
token = 'vr9XvKS1pWTlM3XiB6rpZ9uT+A0Dtfy1eKPDzIubBvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)