UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MZq6YNZZKVwKclHhOeD54MiOZqOplSESwvXEvJa4HbY='
WHERE
key_id = '386ed8fe1755ddba840af9f5186720b3ba5ad649e511d86863892b44657a39d4'
AND (
token = 'MZq6YNZZKVwKclHhOeD54MiOZqOplSESwvXEvJa4HbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)