UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RvlwrdHlDq0IPjy4Yiudoae46o+DIh4bjVOY8YlbYgM='
WHERE
key_id = 'cab706ee13bd95b26bdeff002faa43acfe5893b3ac57d32801ef876742a93d21'
AND (
token = 'RvlwrdHlDq0IPjy4Yiudoae46o+DIh4bjVOY8YlbYgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)