UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWBdBrB7v1ZHtsMk+bJ0/ALcxjSIqpkkDMar7IUpWnU='
WHERE
key_id = '1f572f4754265b08d0d96b340e8afd0e0511119a6a2facf7941cf6826850f733'
AND (
token = 'oWBdBrB7v1ZHtsMk+bJ0/ALcxjSIqpkkDMar7IUpWnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)