UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9aWQ22WmSvPaoOQS5AnPvPMm0CKXaY2F05fOQr+U/s='
WHERE
key_id = '33578d097d764c6b9eb982656b0d923a4f0ce969de635dd7fc996b636484da95'
AND (
token = 'S9aWQ22WmSvPaoOQS5AnPvPMm0CKXaY2F05fOQr+U/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)