UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvvubHr0aYuV09YwjVngK2C/F035hEjZHPpIPodR4vU='
WHERE
key_id = '527c0ba521907d7de760b39eb162cb3098a0343edecfdf62080fcee6fae3cb9a'
AND (
token = 'pvvubHr0aYuV09YwjVngK2C/F035hEjZHPpIPodR4vU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)