UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hS9wTa8B5M8PyA3Kf5S2J/zHfVMZ5cFe5EG8EXi5NYs='
WHERE
key_id = '9aa25b389a4b3bb17396bcf65105c08dbd3282d42caa760f90033f120aa49345'
AND (
token = 'hS9wTa8B5M8PyA3Kf5S2J/zHfVMZ5cFe5EG8EXi5NYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)