UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NUymxucPrDFjn93OQNGmb3/6jk5ZRpgFxgTj3neFYrA='
WHERE
key_id = '182b32e1bb7f64c304e315f8e89552a24ad4cc3fd061958de525ccd48948716a'
AND (
token = 'NUymxucPrDFjn93OQNGmb3/6jk5ZRpgFxgTj3neFYrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)