UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oqJM3CT4bECLHhBNslGxw/kiEsfIS+2eNaUcDS2c8aw='
WHERE
key_id = 'a731167fed0a2c27bfb79249ff3e95f7956f33f016d2832bfbdd05ae0310a2c6'
AND (
token = 'oqJM3CT4bECLHhBNslGxw/kiEsfIS+2eNaUcDS2c8aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)