UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HE4+A5+NHzA/tOIZL7vRdQHXgctokFL4RSoSiQdBmf4='
WHERE
key_id = '861558b7f92ca599be2b54900bfe144a9bbfade1d047d9c30fc5d5971199b344'
AND (
token = 'HE4+A5+NHzA/tOIZL7vRdQHXgctokFL4RSoSiQdBmf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)