UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W67YcYnYcEWV1ENDCteSvn/i2MWjL/GgJmRi0OCNOkk='
WHERE
key_id = '9d0a6749f2c763c6b86c7b0c06d89afff2238f16712866f821e3200d2dac9362'
AND (
token = 'W67YcYnYcEWV1ENDCteSvn/i2MWjL/GgJmRi0OCNOkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)