UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SnGsS2vUJI2Br/PEb2kSwMsKFI3gd0R6DabtwRYitFk='
WHERE
key_id = 'dbe40fc29f92ceadc82e37153f22a3d312e399a3a6e099cd9b481d9e2936ec73'
AND (
token = 'SnGsS2vUJI2Br/PEb2kSwMsKFI3gd0R6DabtwRYitFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)