UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nVWTE4M+0ns63qPpY2J0A4oTPPU7Vd++fNg/RmNd58='
WHERE
key_id = '9a95ef50704cf6b5de1dfaa710732237dc4a05d9c5e5ce4ce656406aff307bff'
AND (
token = '9nVWTE4M+0ns63qPpY2J0A4oTPPU7Vd++fNg/RmNd58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)