UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6V0hK7D618wvwuq98xUQcXHgjUy+69/NjC867Y7QYzU='
WHERE
key_id = '4ae60d1695cfb86a82e8ce1ca33c47ca42aa84b1cffbf5a60b3b088a3d3b61de'
AND (
token = '6V0hK7D618wvwuq98xUQcXHgjUy+69/NjC867Y7QYzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)