UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXaRwvFhkqxQG6sNjDTb46a8vV8so9OeLaSdN4tYsdU='
WHERE
key_id = '1d2d27125be69ff85a1b784c0fa5a86fc7a63e91f1ff3ab3ed717fc618dfd7bf'
AND (
token = 'XXaRwvFhkqxQG6sNjDTb46a8vV8so9OeLaSdN4tYsdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)