UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMwosXZbjTkCurolpLmk8bMV7vTce+ZDyda2Rw5YmYI='
WHERE
key_id = 'd43947ef68c21407f4813dd59a922816f0d862d976f25baba6f9523e959b2d99'
AND (
token = 'nMwosXZbjTkCurolpLmk8bMV7vTce+ZDyda2Rw5YmYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)