UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V6Qg1Km42U4ic3FZtKQPRsOGhF81lMAeOzy3YYVpUM8='
WHERE
key_id = 'd2e13173d62e61dd55addc691c58369ae1ebbb2c07ceb0108cf76233a2ee1706'
AND (
token = 'V6Qg1Km42U4ic3FZtKQPRsOGhF81lMAeOzy3YYVpUM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)